package net.messagenet.mazor.infra.persistence;

public interface HQLQueries {
	public static final String GET_ALL_CUSTOMERS="from Customer";
	public static final String GET_CUSTOMER_BY_NAME="from Customer where name=?1";
	public static final String GET_PRODUCT = "from DpaProduct where dialogicItemKey=?1 and draft = false";
	public static final String GET_ALL_PRODUCT = "from Product";
	//public static final String GET_ALL_NOT_EXPIRED_DPAS = "from Dpa where dpaId is not null and current_date() < expirationDate";
	public static final String GET_ALL_NOT_EXPIRED_DPAS = "from Dpa where dpaId is not null and draft = false";
	public static final String GET_REPORTED_PRDS_FROM_DPAS = "from DpaProduct where quantityPaid < quantityReported and quantityReported !=0 and" +
															" dpa.requestDate >=:fromDate and dpa.requestDate <=:toDate and draft = false ";
	public static final String GET_DPA_DRAFTS = "from Dpa where draft = true";
	public static final String GET_POS_DRAFTS = "from Pos where draft = true";
	public static final String GET_NOT_CLOSED_DPA = "from Dpa where draft = false and approved = true and closed=false";
	public static final String GET_CLOSED_DPA = "from Dpa where draft = false and( approved = false or closed=true)";
	public static final String GET_ALL_DPAS = "from Dpa where draft = false ";
}
